﻿using System;

namespace edowork.com.Model
{
    #region supplierInfo

    [Serializable]
    public class supplierInfo
    {
        #region Private fields

        protected string _supplierid = String.Empty;
        protected string _suppliername = String.Empty;
        protected string _address = String.Empty;
        protected string _contact = String.Empty;
        protected string _mobile = String.Empty;
        protected string _email = String.Empty;
        protected string _telephone = String.Empty;
        protected string _fax = String.Empty;
        protected string _qq = String.Empty;
        protected string _settleid = String.Empty;
        protected string _creditid = String.Empty;
        protected string _sysdate = String.Empty;

        #endregion

        public supplierInfo() { }

        #region Public Properties

        public string Supplierid
        {
            get { return _supplierid; }
            set { _supplierid = value; }
        }

        public string Suppliername
        {
            get { return _suppliername; }
            set { _suppliername = value; }
        }

        public string Address
        {
            get { return _address; }
            set { _address = value; }
        }

        public string Contact
        {
            get { return _contact; }
            set { _contact = value; }
        }

        public string Mobile
        {
            get { return _mobile; }
            set { _mobile = value; }
        }

        public string Email
        {
            get { return _email; }
            set { _email = value; }
        }

        public string Telephone
        {
            get { return _telephone; }
            set { _telephone = value; }
        }

        public string Fax
        {
            get { return _fax; }
            set { _fax = value; }
        }

        public string Qq
        {
            get { return _qq; }
            set { _qq = value; }
        }

        public string Settleid
        {
            get { return _settleid; }
            set { _settleid = value; }
        }

        public string Creditid
        {
            get { return _creditid; }
            set { _creditid = value; }
        }

        public string Sysdate
        {
            get { return _sysdate; }
            set { _sysdate = value; }
        }

        #endregion

        #region Public SQL Script

        public string SQL_Insert()
        {
            return "insert into supplier(Supplierid,Suppliername,Address,Contact,Mobile,Email,Telephone,Fax,Qq,Settleid,Creditid,Sysdate) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')";
        }

        #endregion

    }

    #endregion
}

